﻿<%@ Page Title="" Language="C#" MasterPageFile="~/masterPage.Master" AutoEventWireup="true" CodeFile="ckjf.aspx.cs" Inherits="ckjf" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
        DataSourceID="SqlDataSourcejf" EnableModelValidation="True" Width="462px">
        <Columns>
            <asp:HyperLinkField DataNavigateUrlFields="jfID" 
                DataNavigateUrlFormatString="jfView.aspx?jfID={0}" DataTextField="j_Name" 
                HeaderText="机房名称" />
            <asp:BoundField DataField="c_Name" HeaderText="机房类型" SortExpression="c_Name" />
            <asp:BoundField DataField="j_jsh" HeaderText="教室号" SortExpression="j_jsh" />
            <asp:BoundField DataField="j_kfsj_s" HeaderText="开放时间" 
                SortExpression="j_kfsj_s" />
            <asp:BoundField DataField="j_kfsj_e" HeaderText="关闭时间" 
                SortExpression="j_kfsj_e" />
        </Columns>
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSourcejf" runat="server" 
        ConnectionString="<%$ ConnectionStrings:LabInfoManageSystemConnectionString %>" 
        SelectCommand="SELECT jfInfo.jfID, jfInfo.j_Name, classInfo.c_Name, jfInfo.j_jsh, jfInfo.j_kfsj_s, jfInfo.j_kfsj_e FROM classInfo INNER JOIN jfInfo ON classInfo.cID = jfInfo.j_class">
    </asp:SqlDataSource>
</asp:Content>

